Restore a Sql Server Vault To Another Server
A Meridian vault can be moved to another computer (for example, as a server upgrade) by restoring a backup of the vault made on the original server and by modifying the vault configuration file.
Important!
To move (by restoring from backup) a vault from a pre-Windows Server 2008 computer (including Windows XP, Windows Server 2000, or Windows Server 2003) to a post-Windows Server 2008 (including Windows Vista) or later computer, see Change Operating System Versions.
Note:
- The following task assumes the Meridian vault is hosted on a dedicated SQL Server computer. For alternative environments, modify the paths accordingly.
- The paths specified must all exist prior to restoring the vault.
- The location \\<ServerShare>\BC-Meridian Vaults\<Vault>\Backup must be accessible (Full Control) from the SQL Server computer.
- The location specified for LocalDataPath is used heavily for write-ahead log files, so it should be high-performance. We recommend a local SSD drive.
- The location specified for BackupLocation does not need to be high-performance and can be on a network share, if desired.
To restore a SQL Server vault on another server:
- On the original server, create a backup of the vault as described in Prepare For Backups.
- Edit the resulting DataStore.ini file in any text editor and change or add the following settings. For descriptions of each setting, see HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Installed DataStores\<vaultname>\CompoundItemService and HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Installed DataStores\<vaultname>\StreamService.
- LocalDataPath=S_\\<ServerShare>\BC-Meridian Vaults\<Vault>
- BackupLocation=S_\\<ServerShare>\BC-Meridian Vaults\<Vault>\Backup
- Servername=S_<SQLServerName>\<SQLServerInstance>
- DataPath=S_<SQLServerDrive>:\BC-Meridian Vaults\<Vault>
- IndexPath=S_<SQLServerDrive>:\BC-Meridian Vaults\<Vault>
- LogPath=S_<SQLServerDrive>:\BC-Meridian Vaults\<Vault>
- RootPath=S_\\<ServerShare>\BC-Meridian Vaults\<Vault>
- Copy the modified DataStore.ini file and the contents of the Backup folder from the old server to the new server location \\<ServerShare>\BC-Meridian Vaults\<Vault>\Backup.
- Copy the vault streams folders from the old server to the new server location <ServerShare>\BC-Meridian Vaults\<Vault>.
- On the new server, restore the vault using the modified DataStore.ini file as described in Restore Backups.
